package com.huangwenshuo.futurestarschoolmanagement.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huangwenshuo.futurestarschoolmanagement.pojo.dto.Page;
import com.huangwenshuo.futurestarschoolmanagement.pojo.po.Students;
import com.huangwenshuo.futurestarschoolmanagement.pojo.vo.StudentVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author huangwenshuo
 * @since 2020-12-24
 */
@Mapper
public interface StudentsMapper extends BaseMapper<Students> {

    List<StudentVo> getStuPages(@Param("dto") Page page);


    Integer getStuTotal(@Param("dto") Page page);

    List<String> getClassNames(@Param("dto")Page page);

    List<String> getPositionNames(@Param("dto")Page page);

    void updateStu(@Param("uid")String uid, @Param("cid")Integer classId, @Param("pid")Integer positionId);

    void deleteStu(String uid);

    Map<String, Object> SelectStu(@Param("uid")Integer uid, @Param("cid")Integer classId);

    void addStu(@Param("uid")Integer uid, @Param("cid")Integer classId, @Param("pid")Integer positionId);

    List<StudentVo> exportStu(@Param("dto")Page page);
}
